Pine Valley Furniture Company Database

Consider the Pine Valley Furniture Company database designed and implemented using structured query language during the previous semester. Try to recall major relations in the database: CUSTOMER_T, ORDER_T, ORDER_LINE_T, and PRODUCT_T.

There is a need to implement a web-based solution for the above-mentioned database. The web-based solution must incorporate the following functionalities:

1. New Customer Registration
2. Searching of Products
3. Products Selection and Order Placement
4. Product Catalog Update
5. Payment Provision

• As a first step, design the above-mentioned 1 to 5 user interfaces using paper and pencil. Next, write appropriate HTML for creating 1 to 5 user interface prototypes.
• Create links for navigation among the above pages.
• Design a menu using a list and styles.
• Add help pages for user guidance.
• Either use a table for layout or opt for a flow-based layout.
• Test user interface prototypes in the browser.
• Experiment with style sheets.